<?php

namespace App\Http\Controllers\Admin;

use Illuminate\Http\Request;

use App\Http\Requests;
use App\Http\Controllers\Controller;
use App\Model\Cat;
use DB;

class CatController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $cats =$this->findAll();
        return view('admin.cat_index')->with('cats',$cats);
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {

        $cats =$this->findAll();
        return view('admin.cat_add')->with('cats',$cats);
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        // dd($request->parent_id);
        //验证
        $cat = new Cat();
        $cat->parent_id=$request->parent_id;
        $cat->cat_name = $request->cat_name;
        $cat->save();
        return redirect('admin/cat');
    }

    /**
     * Display the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function show($id)
    {
        //

    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {
        //获取数据
        $cats = DB::table('cats')->where('cat_id',$id)->first();
        // dd($cats);
        return view('admin.cat_edit')->with('cats',$cats);
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, $id)
    {
        //
        $catname = $request->catname;
        DB::table('cats')->where('cat_id',$request->catid)->update(['cat_name'=>$catname]);
        return redirect('admin/cat');
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {
        //
    }


    /**
     * 找子孙栏目
     * @param $data  栏目数据源
     * @param int $id
     * @param int $lev
     * @return array
     */
    protected  function  findTree($data,$id=0,$lev=0)
    {
        static $tree=[];
        foreach($data as $k=>$v){
            if($v->parent_id==$id){
                $v->lev=$lev;
                $tree[] = $v;
                $this->findTree($data,$v->cat_id,$lev+1);
            }
        }
        return $tree;
    }
    //格式化取出所有栏目
    protected function findAll()
    {
        $data = Cat::select('cat_id','parent_id','cat_name')->get();
        return  $this->findTree($data,0,0);
    }

    public function delete($id){
        $data = DB::table('cats')->where('cat_id',$id)->delete();
        return redirect('admin/cat');
    }

}
